﻿CREATE TABLE [dbo].[Employee] (
    [EmployeeNo]  VARCHAR (10)  NOT NULL,
    [ChineseName] VARCHAR (20)  NULL,
    [EnglishName] VARCHAR (30)  NULL,
    [Title]       VARCHAR (30)  NULL,
    [Gender]      VARCHAR (2)   NULL,
    [Tel]         VARCHAR (15)  NULL,
    [Mobile]      VARCHAR (15)  NULL,
    [Address]     VARCHAR (200) NULL,
    [ZipCode]     VARCHAR (6)   NULL,
    [IDCardNo]    VARCHAR (18)  NULL,
    [HireDate]    DATETIME      NULL,
    [Department]  VARCHAR (20)  NULL,
    [LoginID]     VARCHAR (20)  NULL,
    [RecordID]    INT           IDENTITY (1, 1) NOT NULL
);

